Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 118277 |
| Missing cells | 325 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 76.3 MiB |
| Average record size in memory | 676.3 B |
Variable types
| NUM | 11 |
|---|---|
| CAT | 10 |
| DATE | 3 |
Reproduction
| Analysis started | 2020-04-26 17:55:51.820968 |
|---|---|
| Analysis finished | 2020-04-26 18:00:56.451218 |
| Version | pandas-profiling v2.6.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Landkreis has a high cardinality: 412 distinct values | High cardinality |
IdLandkreis has a high cardinality: 412 distinct values | High cardinality |
ObjectId is highly correlated with IdBundesland | High Correlation |
IdBundesland is highly correlated with ObjectId | High Correlation |
NeuerTodesfall is highly correlated with AnzahlTodesfall | High Correlation |
AnzahlTodesfall is highly correlated with NeuerTodesfall | High Correlation |
Cases deaths is highly correlated with Cases confirmed and 3 other fields | High Correlation |
Cases confirmed is highly correlated with Cases deaths and 3 other fields | High Correlation |
Cases Recovered is highly correlated with Cases confirmed and 3 other fields | High Correlation |
Cases non-lethal is highly correlated with Cases confirmed and 3 other fields | High Correlation |
ratio_deaths is highly correlated with Cases confirmed and 3 other fields | High Correlation |
AnzahlTodesfall has 113000 (95.5%) zeros | Zeros |
AnzahlGenesen has 30067 (25.4%) zeros | Zeros |
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.504147746010807 |
|---|---|
| Minimum | 1.0 |
| Maximum | 16.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 8 |
| Q3 | 9 |
| 95-th percentile | 14 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.021735819 |
|---|---|
| Coefficient of variation (CV) | 0.4026754165 |
| Kurtosis | 0.4148267835 |
| Mean | 7.504147746 |
| Median Absolute Deviation (MAD) | 2.370551448 |
| Skewness | 0.3574097156 |
| Sum | 887418 |
| Variance | 9.130887359 |
| Value | Count | Frequency (%) | |
| 9 | 29166 | 24.7% | |
| 5 | 24535 | 20.7% | |
| 8 | 22756 | 19.2% | |
| 3 | 7947 | 6.7% | |
| 6 | 6905 | 5.8% | |
| 7 | 5094 | 4.3% | |
| 11 | 5016 | 4.2% | |
| 14 | 3491 | 3.0% | |
| 1 | 2380 | 2.0% | |
| 12 | 2370 | 2.0% | |
| Other values (6) | 8597 | 7.3% |
| Value | Count | Frequency (%) | |
| 1 | 2380 | 2.0% | |
| 2 | 2272 | 1.9% | |
| 3 | 7947 | 6.7% | |
| 4 | 569 | 0.5% | |
| 5 | 24535 | 20.7% |
| Value | Count | Frequency (%) | |
| 16 | 1953 | 1.7% | |
| 15 | 1290 | 1.1% | |
| 14 | 3491 | 3.0% | |
| 13 | 618 | 0.5% | |
| 12 | 2370 | 2.0% |
Bundesland
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| Bayern | |
|---|---|
| Nordrhein-Westfalen | |
| Baden-Württemberg | |
| Niedersachsen | |
| Hessen | |
| Other values (11) |
| Value | Count | Frequency (%) | |
| Bayern | 29166 | 24.7% | |
| Nordrhein-Westfalen | 24535 | 20.7% | |
| Baden-Württemberg | 22756 | 19.2% | |
| Niedersachsen | 7947 | 6.7% | |
| Hessen | 6905 | 5.8% | |
| Rheinland-Pfalz | 5094 | 4.3% | |
| Berlin | 5016 | 4.2% | |
| Sachsen | 3491 | 3.0% | |
| Schleswig-Holstein | 2380 | 2.0% | |
| Brandenburg | 2370 | 2.0% | |
| Other values (6) | 8597 | 7.3% |
Length
| Max length | 22 |
|---|---|
| Mean length | 12.31328153 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 23 | 65.7% | |
| Uppercase_Letter | 11 | 31.4% | |
| Dash_Punctuation | 1 | 2.9% |
| Value | Count | Frequency (%) | |
| Latin | 34 | 97.1% | |
| Common | 1 | 2.9% |
| Value | Count | Frequency (%) | |
| ASCII | 34 | 100.0% |
| Distinct count | 412 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| SK München | 2438 |
|---|---|
| SK Hamburg | 2272 |
| StadtRegion Aachen | 1369 |
| LK Heinsberg | 1358 |
| LK Esslingen | 1246 |
| Other values (407) |
| Value | Count | Frequency (%) | |
| SK München | 2438 | 2.1% | |
| SK Hamburg | 2272 | 1.9% | |
| StadtRegion Aachen | 1369 | 1.2% | |
| LK Heinsberg | 1358 | 1.1% | |
| LK Esslingen | 1246 | 1.1% | |
| Region Hannover | 1217 | 1.0% | |
| LK Ludwigsburg | 1205 | 1.0% | |
| SK Köln | 1065 | 0.9% | |
| SK Frankfurt am Main | 976 | 0.8% | |
| SK Stuttgart | 922 | 0.8% | |
| Other values (402) | 104189 | 88.1% |
Length
| Max length | 36 |
|---|---|
| Mean length | 14.26399046 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 28 | 50.0% | |
| Uppercase_Letter | 23 | 41.1% | |
| Open_Punctuation | 1 | 1.8% | |
| Dash_Punctuation | 1 | 1.8% | |
| Other_Punctuation | 1 | 1.8% | |
| Close_Punctuation | 1 | 1.8% | |
| Space_Separator | 1 | 1.8% |
| Value | Count | Frequency (%) | |
| Latin | 51 | 91.1% | |
| Common | 5 | 8.9% |
| Value | Count | Frequency (%) | |
| ASCII | 52 | 100.0% |
Altersgruppe
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| A35-A59 | |
|---|---|
| A15-A34 | |
| A60-A79 | |
| A80+ | |
| A05-A14 | 2848 |
| Other values (2) | 1393 |
| Value | Count | Frequency (%) | |
| A35-A59 | 47862 | 40.5% | |
| A15-A34 | 28966 | 24.5% | |
| A60-A79 | 24580 | 20.8% | |
| A80+ | 12608 | 10.7% | |
| A05-A14 | 2848 | 2.4% | |
| A00-A04 | 1211 | 1.0% | |
| unbekannt | 182 | 0.2% | |
| (Missing) | 20 | < 0.1% |
Length
| Max length | 9 |
|---|---|
| Mean length | 6.682609468 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 9 | 47.4% | |
| Lowercase_Letter | 7 | 36.8% | |
| Uppercase_Letter | 1 | 5.3% | |
| Math_Symbol | 1 | 5.3% | |
| Dash_Punctuation | 1 | 5.3% |
| Value | Count | Frequency (%) | |
| Common | 11 | 57.9% | |
| Latin | 8 | 42.1% |
| Value | Count | Frequency (%) | |
| ASCII | 19 | 100.0% |
Geschlecht
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| W | |
|---|---|
| M | |
| unbekannt | 397 |
| Value | Count | Frequency (%) | |
| W | 60677 | 51.3% | |
| M | 57183 | 48.3% | |
| unbekannt | 397 | 0.3% | |
| (Missing) | 20 | < 0.1% |
Length
| Max length | 9 |
|---|---|
| Mean length | 1.027190409 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 7 | 77.8% | |
| Uppercase_Letter | 2 | 22.2% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
AnzahlFall
Real number (ℝ)
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.303373161842428 |
|---|---|
| Minimum | -1.0 |
| Maximum | 49.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 49 |
| Range | 50 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.184558027 |
|---|---|
| Coefficient of variation (CV) | 0.9088402784 |
| Kurtosis | 201.6147141 |
| Mean | 1.303373162 |
| Median Absolute Deviation (MAD) | 0.514612983 |
| Skewness | 10.779774 |
| Sum | 154133 |
| Variance | 1.40317772 |
| Value | Count | Frequency (%) | |
| 1 | 99981 | 84.5% | |
| 2 | 11837 | 10.0% | |
| 3 | 3113 | 2.6% | |
| 4 | 1263 | 1.1% | |
| 5 | 636 | 0.5% | |
| 6 | 413 | 0.3% | |
| 7 | 264 | 0.2% | |
| 8 | 175 | 0.1% | |
| 9 | 124 | 0.1% | |
| 10 | 87 | 0.1% | |
| Other values (30) | 364 | 0.3% |
| Value | Count | Frequency (%) | |
| -1 | 42 | < 0.1% | |
| 1 | 99981 | 84.5% | |
| 2 | 11837 | 10.0% | |
| 3 | 3113 | 2.6% | |
| 4 | 1263 | 1.1% |
| Value | Count | Frequency (%) | |
| 49 | 1 | < 0.1% | |
| 42 | 2 | < 0.1% | |
| 38 | 2 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 36 | 2 | < 0.1% |
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.04766736852786727 |
|---|---|
| Minimum | -1.0 |
| Maximum | 9.0 |
| Zeros | 113000 |
| Zeros (%) | 95.5% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2342722029 |
|---|---|
| Coefficient of variation (CV) | 4.914729093 |
| Kurtosis | 72.40976486 |
| Mean | 0.04766736853 |
| Median Absolute Deviation (MAD) | 0.09114987943 |
| Skewness | 6.434891355 |
| Sum | 5637 |
| Variance | 0.05488346506 |
| Value | Count | Frequency (%) | |
| 0 | 113000 | 95.5% | |
| 1 | 4972 | 4.2% | |
| 2 | 218 | 0.2% | |
| 3 | 40 | < 0.1% | |
| 4 | 14 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| -1 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| (Missing) | 20 | < 0.1% |
| Value | Count | Frequency (%) | |
| -1 | 3 | < 0.1% | |
| 0 | 113000 | 95.5% | |
| 1 | 4972 | 4.2% | |
| 2 | 218 | 0.2% | |
| 3 | 40 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 5 | 7 | < 0.1% | |
| 4 | 14 | < 0.1% | |
| 3 | 40 | < 0.1% |
| Distinct count | 118257 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3825102.0 |
|---|---|
| Minimum | 3765974.0 |
| Maximum | 3884230.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 3765974 |
|---|---|
| 5-th percentile | 3771886.8 |
| Q1 | 3795538 |
| median | 3825102 |
| Q3 | 3854666 |
| 95-th percentile | 3878317.2 |
| Maximum | 3884230 |
| Range | 118256 |
| Interquartile range (IQR) | 59128 |
Descriptive statistics
| Standard deviation | 34137.99973 |
|---|---|
| Coefficient of variation (CV) | 0.008924729257 |
| Kurtosis | -1.2 |
| Mean | 3825102 |
| Median Absolute Deviation (MAD) | 29564.25 |
| Skewness | -8.502173037e-18 |
| Sum | 4.523450872e+11 |
| Variance | 1165403026 |
| Value | Count | Frequency (%) | |
| 3783526 | 1 | < 0.1% | |
| 3798724 | 1 | < 0.1% | |
| 3854759 | 1 | < 0.1% | |
| 3867524 | 1 | < 0.1% | |
| 3804047 | 1 | < 0.1% | |
| 3783530 | 1 | < 0.1% | |
| 3867521 | 1 | < 0.1% | |
| 3791963 | 1 | < 0.1% | |
| 3854755 | 1 | < 0.1% | |
| 3798778 | 1 | < 0.1% | |
| Other values (118247) | 118247 | > 99.9% | |
| (Missing) | 20 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3765974 | 1 | < 0.1% | |
| 3765975 | 1 | < 0.1% | |
| 3765976 | 1 | < 0.1% | |
| 3765977 | 1 | < 0.1% | |
| 3765978 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3884230 | 1 | < 0.1% | |
| 3884229 | 1 | < 0.1% | |
| 3884228 | 1 | < 0.1% | |
| 3884227 | 1 | < 0.1% | |
| 3884226 | 1 | < 0.1% |
Meldedatum
Date
| Distinct count | 75 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| Minimum | 2020-01-28 00:00:00 |
|---|---|
| Maximum | 2020-04-25 00:00:00 |
| Distinct count | 412 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| 09162 | 2438 |
|---|---|
| 02000 | 2272 |
| 05334 | 1369 |
| 05370 | 1358 |
| 08116 | 1246 |
| Other values (407) |
| Value | Count | Frequency (%) | |
| 09162 | 2438 | 2.1% | |
| 02000 | 2272 | 1.9% | |
| 05334 | 1369 | 1.2% | |
| 05370 | 1358 | 1.1% | |
| 08116 | 1246 | 1.1% | |
| 03241 | 1217 | 1.0% | |
| 08118 | 1205 | 1.0% | |
| 05315 | 1065 | 0.9% | |
| 06412 | 976 | 0.8% | |
| 08111 | 922 | 0.8% | |
| Other values (402) | 104189 | 88.1% |
Length
| Max length | 5 |
|---|---|
| Mean length | 4.999661811 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 83.3% | |
| Lowercase_Letter | 2 | 16.7% |
| Value | Count | Frequency (%) | |
| Common | 10 | 83.3% | |
| Latin | 2 | 16.7% |
| Value | Count | Frequency (%) | |
| ASCII | 12 | 100.0% |
Datenstand
Categorical
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| 26.04.2020, 00:00 Uhr |
|---|
| Value | Count | Frequency (%) | |
| 26.04.2020, 00:00 Uhr | 118257 | > 99.9% | |
| (Missing) | 20 | < 0.1% |
Length
| Max length | 21 |
|---|---|
| Mean length | 20.9969563 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 30.8% | |
| Lowercase_Letter | 4 | 30.8% | |
| Other_Punctuation | 3 | 23.1% | |
| Uppercase_Letter | 1 | 7.7% | |
| Space_Separator | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Common | 8 | 61.5% | |
| Latin | 5 | 38.5% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
NeuerFall
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| 0 | |
|---|---|
| 1 | 1314 |
| -1 | 42 |
| Value | Count | Frequency (%) | |
| 0 | 116901 | 98.8% | |
| 1 | 1314 | 1.1% | |
| -1 | 42 | < 0.1% | |
| (Missing) | 20 | < 0.1% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.000355099 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 2 | 33.3% | |
| Decimal_Number | 2 | 33.3% | |
| Other_Punctuation | 1 | 16.7% | |
| Dash_Punctuation | 1 | 16.7% |
| Value | Count | Frequency (%) | |
| Common | 4 | 66.7% | |
| Latin | 2 | 33.3% |
| Value | Count | Frequency (%) | |
| ASCII | 6 | 100.0% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| -9 | |
|---|---|
| 0 | 5114 |
| 1 | 140 |
| -1 | 3 |
| Value | Count | Frequency (%) | |
| -9 | 113000 | 95.5% | |
| 0 | 5114 | 4.3% | |
| 1 | 140 | 0.1% | |
| -1 | 3 | < 0.1% | |
| (Missing) | 20 | < 0.1% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.955409758 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 42.9% | |
| Lowercase_Letter | 2 | 28.6% | |
| Other_Punctuation | 1 | 14.3% | |
| Dash_Punctuation | 1 | 14.3% |
| Value | Count | Frequency (%) | |
| Common | 5 | 71.4% | |
| Latin | 2 | 28.6% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
Refdatum
Date
| Distinct count | 97 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2020-04-25 00:00:00 |
NeuGenesen
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| 0 | |
|---|---|
| -9 | |
| 1 | 1868 |
| -1 | 90 |
| Value | Count | Frequency (%) | |
| 0 | 86232 | 72.9% | |
| -9 | 30067 | 25.4% | |
| 1 | 1868 | 1.6% | |
| -1 | 90 | 0.1% | |
| (Missing) | 20 | < 0.1% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.254969267 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 42.9% | |
| Lowercase_Letter | 2 | 28.6% | |
| Other_Punctuation | 1 | 14.3% | |
| Dash_Punctuation | 1 | 14.3% |
| Value | Count | Frequency (%) | |
| Common | 5 | 71.4% | |
| Latin | 2 | 28.6% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
| Distinct count | 39 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 20 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9464809694140728 |
|---|---|
| Minimum | -1.0 |
| Maximum | 49.0 |
| Zeros | 30067 |
| Zeros (%) | 25.4% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 49 |
| Range | 50 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.094460745 |
|---|---|
| Coefficient of variation (CV) | 1.156347333 |
| Kurtosis | 214.4165819 |
| Mean | 0.9464809694 |
| Median Absolute Deviation (MAD) | 0.4842508536 |
| Skewness | 9.783965035 |
| Sum | 111928 |
| Variance | 1.197844321 |
| Value | Count | Frequency (%) | |
| 1 | 75043 | 63.4% | |
| 0 | 30067 | 25.4% | |
| 2 | 8899 | 7.5% | |
| 3 | 2190 | 1.9% | |
| 4 | 796 | 0.7% | |
| 5 | 387 | 0.3% | |
| 6 | 233 | 0.2% | |
| 7 | 157 | 0.1% | |
| 8 | 101 | 0.1% | |
| -1 | 90 | 0.1% | |
| Other values (29) | 294 | 0.2% |
| Value | Count | Frequency (%) | |
| -1 | 90 | 0.1% | |
| 0 | 30067 | 25.4% | |
| 1 | 75043 | 63.4% | |
| 2 | 8899 | 7.5% | |
| 3 | 2190 | 1.9% |
| Value | Count | Frequency (%) | |
| 49 | 1 | < 0.1% | |
| 42 | 2 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 36 | 2 | < 0.1% | |
| 33 | 1 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 MiB |
| Germany |
|---|
| Value | Count | Frequency (%) | |
| Germany | 118277 | 100.0% |
Length
| Max length | 7 |
|---|---|
| Mean length | 7 |
| Min length | 7 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 6 | 85.7% | |
| Uppercase_Letter | 1 | 14.3% |
| Value | Count | Frequency (%) | |
| Latin | 7 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
Date
Date
| Distinct count | 95 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 MiB |
| Minimum | 2020-01-22 00:00:00 |
|---|---|
| Maximum | 2020-04-25 00:00:00 |
| Distinct count | 71 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77907.81599127472 |
|---|---|
| Minimum | 0 |
| Maximum | 156513 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5795 |
| Q1 | 37323 |
| median | 77872 |
| Q3 | 118181 |
| 95-th percentile | 148291 |
| Maximum | 156513 |
| Range | 156513 |
| Interquartile range (IQR) | 80858 |
Descriptive statistics
| Standard deviation | 46190.21631 |
|---|---|
| Coefficient of variation (CV) | 0.5928829569 |
| Kurtosis | -1.24053309 |
| Mean | 77907.81599 |
| Median Absolute Deviation (MAD) | 40097.44855 |
| Skewness | -0.03242792417 |
| Sum | 9214702752 |
| Variance | 2133536083 |
| Value | Count | Frequency (%) | |
| 84794 | 4927 | 4.2% | |
| 77872 | 4813 | 4.1% | |
| 91159 | 4657 | 3.9% | |
| 71808 | 4599 | 3.9% | |
| 50871 | 4489 | 3.8% | |
| 43938 | 4417 | 3.7% | |
| 37323 | 4193 | 3.5% | |
| 113296 | 4066 | 3.4% | |
| 107663 | 4043 | 3.4% | |
| 118181 | 3777 | 3.2% | |
| Other values (61) | 74296 | 62.8% |
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 156513 | 453 | 0.4% | |
| 154999 | 1228 | 1.0% | |
| 153129 | 1517 | 1.3% | |
| 150648 | 1806 | 1.5% | |
| 148291 | 1718 | 1.5% |
| Distinct count | 47 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1558.427352739755 |
|---|---|
| Minimum | 0 |
| Maximum | 5877 |
| Zeros | 948 |
| Zeros (%) | 0.8% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 206 |
| median | 920 |
| Q3 | 2607 |
| 95-th percentile | 5033 |
| Maximum | 5877 |
| Range | 5877 |
| Interquartile range (IQR) | 2401 |
Descriptive statistics
| Standard deviation | 1630.516699 |
|---|---|
| Coefficient of variation (CV) | 1.046257752 |
| Kurtosis | -0.07903768726 |
| Mean | 1558.427353 |
| Median Absolute Deviation (MAD) | 1354.132757 |
| Skewness | 1.021408187 |
| Sum | 184326112 |
| Variance | 2658584.707 |
| Value | Count | Frequency (%) | |
| 1107 | 4927 | 4.2% | |
| 920 | 4813 | 4.1% | |
| 1275 | 4657 | 3.9% | |
| 775 | 4599 | 3.9% | |
| 342 | 4489 | 3.8% | |
| 267 | 4417 | 3.7% | |
| 206 | 4193 | 3.5% | |
| 2349 | 4066 | 3.4% | |
| 2016 | 4043 | 3.4% | |
| 2607 | 3777 | 3.2% | |
| Other values (37) | 74296 | 62.8% |
| Value | Count | Frequency (%) | |
| 0 | 948 | 0.8% | |
| 2 | 823 | 0.7% | |
| 3 | 1470 | 1.2% | |
| 7 | 1125 | 1.0% | |
| 9 | 936 | 0.8% |
| Value | Count | Frequency (%) | |
| 5877 | 453 | 0.4% | |
| 5760 | 1228 | 1.0% | |
| 5575 | 1517 | 1.3% | |
| 5279 | 1806 | 1.5% | |
| 5033 | 1718 | 1.5% |
| Distinct count | 47 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29806.39945213355 |
|---|---|
| Minimum | 0.0 |
| Maximum | 109800.0 |
| Zeros | 32 |
| Zeros (%) | < 0.1% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 46 |
| Q1 | 3547 |
| median | 18700 |
| Q3 | 52407 |
| 95-th percentile | 95200 |
| Maximum | 109800 |
| Range | 109800 |
| Interquartile range (IQR) | 48860 |
Descriptive statistics
| Standard deviation | 31300.13795 |
|---|---|
| Coefficient of variation (CV) | 1.050114691 |
| Kurtosis | -0.2505260738 |
| Mean | 29806.39945 |
| Median Absolute Deviation (MAD) | 26017.80681 |
| Skewness | 0.9688453174 |
| Sum | 3525411508 |
| Variance | 979698635.5 |
| Value | Count | Frequency (%) | |
| 28700 | 4987 | 4.2% | |
| 22440 | 4927 | 4.2% | |
| 18700 | 4813 | 4.1% | |
| 24575 | 4657 | 3.9% | |
| 266 | 4638 | 3.9% | |
| 16100 | 4599 | 3.9% | |
| 6658 | 4489 | 3.8% | |
| 5673 | 4417 | 3.7% | |
| 3547 | 4193 | 3.5% | |
| 46300 | 4066 | 3.4% | |
| Other values (37) | 72491 | 61.3% |
| Value | Count | Frequency (%) | |
| 0 | 32 | < 0.1% | |
| 1 | 5 | < 0.1% | |
| 12 | 3 | < 0.1% | |
| 14 | 9 | < 0.1% | |
| 15 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 109800 | 1681 | 1.4% | |
| 103300 | 1517 | 1.3% | |
| 99400 | 1806 | 1.5% | |
| 95200 | 1718 | 1.5% | |
| 91500 | 1296 | 1.1% |
Cases active
Real number (ℝ≥0)
| Distinct count | 72 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46542.98918640141 |
|---|---|
| Minimum | 0.0 |
| Maximum | 72864.0 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5738 |
| Q1 | 33570 |
| median | 52740 |
| Q3 | 63167 |
| 95-th percentile | 69566 |
| Maximum | 72864 |
| Range | 72864 |
| Interquartile range (IQR) | 29597 |
Descriptive statistics
| Standard deviation | 19951.3078 |
|---|---|
| Coefficient of variation (CV) | 0.4286640833 |
| Kurtosis | -0.5251794794 |
| Mean | 46542.98919 |
| Median Absolute Deviation (MAD) | 16716.08885 |
| Skewness | -0.78442387 |
| Sum | 5504965132 |
| Variance | 398054682.8 |
| Value | Count | Frequency (%) | |
| 61247 | 4927 | 4.2% | |
| 58252 | 4813 | 4.1% | |
| 65309 | 4657 | 3.9% | |
| 54933 | 4599 | 3.9% | |
| 43871 | 4489 | 3.8% | |
| 37998 | 4417 | 3.7% | |
| 33570 | 4193 | 3.5% | |
| 64647 | 4066 | 3.4% | |
| 69566 | 4043 | 3.4% | |
| 63167 | 3777 | 3.2% | |
| Other values (62) | 74296 | 62.8% |
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 7 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 72864 | 2937 | 2.5% | |
| 69839 | 2050 | 1.7% | |
| 69566 | 4043 | 3.4% | |
| 68248 | 3396 | 2.9% | |
| 65491 | 2609 | 2.2% |
| Distinct count | 71 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76349.38863853496 |
|---|---|
| Minimum | 0 |
| Maximum | 150636 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5784 |
| Q1 | 37117 |
| median | 76952 |
| Q3 | 115574 |
| 95-th percentile | 143258 |
| Maximum | 150636 |
| Range | 150636 |
| Interquartile range (IQR) | 78457 |
Descriptive statistics
| Standard deviation | 44689.58856 |
|---|---|
| Coefficient of variation (CV) | 0.5853300119 |
| Kurtosis | -1.248316835 |
| Mean | 76349.38864 |
| Median Absolute Deviation (MAD) | 38858.85926 |
| Skewness | -0.06769923816 |
| Sum | 9030376640 |
| Variance | 1997159326 |
| Value | Count | Frequency (%) | |
| 83687 | 4927 | 4.2% | |
| 76952 | 4813 | 4.1% | |
| 89884 | 4657 | 3.9% | |
| 71033 | 4599 | 3.9% | |
| 50529 | 4489 | 3.8% | |
| 43671 | 4417 | 3.7% | |
| 37117 | 4193 | 3.5% | |
| 110947 | 4066 | 3.4% | |
| 105647 | 4043 | 3.4% | |
| 115574 | 3777 | 3.2% | |
| Other values (61) | 74296 | 62.8% |
| Value | Count | Frequency (%) | |
| 0 | 5 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 4 | 5 | < 0.1% | |
| 5 | 4 | < 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 150636 | 453 | 0.4% | |
| 149239 | 1228 | 1.0% | |
| 147554 | 1517 | 1.3% | |
| 145369 | 1806 | 1.5% | |
| 143258 | 1718 | 1.5% |
| Distinct count | 49 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4140712299647697 |
|---|---|
| Minimum | 0.0 |
| Maximum | 3.754959651913899 |
| Zeros | 943 |
| Zeros (%) | 0.8% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1962922574 |
| Q1 | 0.551938483 |
| median | 1.18142593 |
| Q3 | 2.190412143 |
| 95-th percentile | 3.394002333 |
| Maximum | 3.754959652 |
| Range | 3.754959652 |
| Interquartile range (IQR) | 1.63847366 |
Descriptive statistics
| Standard deviation | 1.020140528 |
|---|---|
| Coefficient of variation (CV) | 0.7214208917 |
| Kurtosis | -0.7230149558 |
| Mean | 1.41407123 |
| Median Absolute Deviation (MAD) | 0.8613582077 |
| Skewness | 0.6289221265 |
| Sum | 167245.0325 |
| Variance | 1.040686696 |
| Value | Count | Frequency (%) | |
| 1.3055169 | 4927 | 4.2% | |
| 1.18142593 | 4813 | 4.1% | |
| 1.398655097 | 4657 | 3.9% | |
| 1.079266934 | 4599 | 3.9% | |
| 0.6722887303 | 4489 | 3.8% | |
| 0.6076744504 | 4417 | 3.7% | |
| 0.551938483 | 4193 | 3.5% | |
| 2.073330038 | 4066 | 3.4% | |
| 1.87250959 | 4043 | 3.4% | |
| 2.205938349 | 3777 | 3.2% | |
| Other values (39) | 74291 | 62.8% |
| Value | Count | Frequency (%) | |
| 0 | 943 | 0.8% | |
| 0.1372683596 | 520 | 0.4% | |
| 0.1443695861 | 813 | 0.7% | |
| 0.1572327044 | 657 | 0.6% | |
| 0.1700680272 | 303 | 0.3% |
| Value | Count | Frequency (%) | |
| 3.754959652 | 453 | 0.4% | |
| 3.716153007 | 1228 | 1.0% | |
| 3.640721222 | 1517 | 1.3% | |
| 3.50419521 | 1806 | 1.5% | |
| 3.394002333 | 1718 | 1.5% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| IdBundesland | Bundesland | Landkreis | Altersgruppe | Geschlecht | AnzahlFall | AnzahlTodesfall | ObjectId | Meldedatum | IdLandkreis | Datenstand | NeuerFall | NeuerTodesfall | Refdatum | NeuGenesen | AnzahlGenesen | Country/Region | Date | Cases confirmed | Cases deaths | Cases Recovered | Cases active | Cases non-lethal | ratio_deaths | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | Schleswig-Holstein | SK Flensburg | A15-A34 | M | 1.0 | 0.0 | 3765974.0 | 2020-03-14 | 01001 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-16 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 1 | 1.0 | Schleswig-Holstein | SK Flensburg | A15-A34 | W | 1.0 | 0.0 | 3765983.0 | 2020-03-14 | 01001 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-12 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 2 | 1.0 | Schleswig-Holstein | SK Flensburg | A35-A59 | M | 1.0 | 0.0 | 3765987.0 | 2020-03-14 | 01001 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-16 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 3 | 1.0 | Schleswig-Holstein | SK Flensburg | A35-A59 | W | 1.0 | 0.0 | 3765989.0 | 2020-03-14 | 01001 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-10 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 4 | 1.0 | Schleswig-Holstein | SK Kiel | A15-A34 | M | 1.0 | 0.0 | 3766013.0 | 2020-03-14 | 01002 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-12 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 5 | 1.0 | Schleswig-Holstein | LK Pinneberg | A15-A34 | M | 1.0 | 0.0 | 3766879.0 | 2020-03-14 | 01056 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-12 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 6 | 1.0 | Schleswig-Holstein | LK Pinneberg | A15-A34 | W | 1.0 | 0.0 | 3766932.0 | 2020-03-14 | 01056 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-13 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 7 | 1.0 | Schleswig-Holstein | LK Pinneberg | A35-A59 | M | 2.0 | 0.0 | 3766981.0 | 2020-03-14 | 01056 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-10 | 0.0 | 2.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 8 | 1.0 | Schleswig-Holstein | LK Pinneberg | A35-A59 | M | 1.0 | 0.0 | 3766982.0 | 2020-03-14 | 01056 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-12 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
| 9 | 1.0 | Schleswig-Holstein | LK Pinneberg | A35-A59 | W | 1.0 | 0.0 | 3767071.0 | 2020-03-14 | 01056 | 26.04.2020, 00:00 Uhr | 0.0 | -9.0 | 2020-03-10 | 0.0 | 1.0 | Germany | 2020-03-14 | 4585 | 9 | 46.0 | 4530.0 | 4576 | 0.196292 |
Last rows
| IdBundesland | Bundesland | Landkreis | Altersgruppe | Geschlecht | AnzahlFall | AnzahlTodesfall | ObjectId | Meldedatum | IdLandkreis | Datenstand | NeuerFall | NeuerTodesfall | Refdatum | NeuGenesen | AnzahlGenesen | Country/Region | Date | Cases confirmed | Cases deaths | Cases Recovered | Cases active | Cases non-lethal | ratio_deaths | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118267 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-08 | 13 | 0 | 0.0 | 13.0 | 13 | 0.0 |
| 118268 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-09 | 14 | 0 | 0.0 | 14.0 | 14 | 0.0 |
| 118269 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-10 | 14 | 0 | 0.0 | 14.0 | 14 | 0.0 |
| 118270 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-13 | 16 | 0 | 1.0 | 15.0 | 16 | 0.0 |
| 118271 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-14 | 16 | 0 | 1.0 | 15.0 | 16 | 0.0 |
| 118272 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-15 | 16 | 0 | 1.0 | 15.0 | 16 | 0.0 |
| 118273 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-17 | 16 | 0 | 1.0 | 15.0 | 16 | 0.0 |
| 118274 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-18 | 16 | 0 | 12.0 | 4.0 | 16 | 0.0 |
| 118275 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-19 | 16 | 0 | 12.0 | 4.0 | 16 | 0.0 |
| 118276 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaT | NaN | NaN | NaN | NaN | NaT | NaN | NaN | Germany | 2020-02-21 | 16 | 0 | 14.0 | 2.0 | 16 | 0.0 |